﻿CREATE TRIGGER [dbo].[TRG_DIRECT_UPDATE]
ON dbo.DIRECT
 AFTER INSERT, UPDATE
AS
BEGIN
    SET NOCOUNT ON;

    UPDATE DIRECT
    SET LAST_UPDATE = GETDATE(), 
    LAST_UPDATE_USER = SUSER_NAME()
    WHERE ID IN (SELECT ID FROM INSERTED)
END